| HousingLease |
| EntityType | Independent |
| Logical Entity Name | HousingLease |
| Default Table Name | HSStudentLeaseHistory |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| HousingLease Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
HSStudentLeaseHistoryID |
INTEGER | NO | ||
| StartDate | DATETIME | NO | ||
| MoveOutDate | DATETIME | YES | ||
| EndDate | DATETIME | NO | ||
| ActualEndDate | DATETIME | YES | ||
AdTermID |
INTEGER | YES | ||
HSLeaseStatusID |
INTEGER | NO | ||
SyStudentID |
INTEGER | NO | ||
HSBuildingRoomsID |
INTEGER | NO | ||
HSStudentApplicationID |
INTEGER | NO | ||
HSMoveOutReasonID |
INTEGER | YES | ||
| LeaseAmount | MONEY(19, 4) | NO | ||
| Frequency | CHAR(1) | NO | ||
| TerminationFee | MONEY(19, 4) | YES | ||
SaBillCodeID |
INTEGER | YES | ||
| UserID | INTEGER | NO | ||
| DateAdded | DATETIME | NO | ||
| DateLstMod | DATETIME | NO | ||
| ts | TIMESTAMP/DATE | NO | ||
| LastPrintDate | DATETIME | YES | ||
StudentEnrollmentPeriodId |
INTEGER | YES | ||
FaStudentAYID |
INTEGER | YES | ||
| Reason | VARCHAR(max) | YES | ||
| DateSelectedOn | CHAR(1) | YES | ||
| IsAcademicYearLease | BIT | NO | ||
SaTransCodeID |
INTEGER | YES | ||
SaBillTermID |
INTEGER | YES | ||
| ManuallyUpdateDates | BIT | NO | ||
| LastFrequency | CHAR(1) | YES | ||
| RoomSwitchDate | DATETIME | YES | ||
| StartDateOnRoomSwitch | DATETIME | YES |
| HousingLease Keys |
| Key Name | Key Type | Keys |
| HSStudentLeaseHistory_HSMoveOutReasonID_N_N_IDX | Inversion Entry | HSMoveOutReasonID |
| HSStudentLeaseHistory_HSLeaseStatusID_N_N_IDX | Inversion Entry | HSLeaseStatusID |
| HSStudentLeaseHistory_AdTermID_N_N_IDX | Inversion Entry | AdTermID |
| HSStudentLeaseHistory_HSBuildingRoomsID_NU_NC_IDX | Inversion Entry | HSBuildingRoomsID |
| HSStudentLeaseHistory_SyStudentID_N_N_IDX | Inversion Entry | SyStudentID |
| HSStudentLeaseHistory_SaBillCodeID_N_N_IDX | Inversion Entry | SaBillCodeID |
| HSStudentLeaseHistory_HSStudentApplicationID_N_N_IDX | Inversion Entry | HSStudentApplicationID |
| HSStudentLeaseHistory_StartDate_EndDate_NU_NC_IDX | Inversion Entry | StartDate, EndDate |
| HSStudentLeaseHistory_HSStudentLeaseHistoryID_U_C_IDX | PrimaryKey | HSStudentLeaseHistoryID |
| HousingLease Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Term | Non-Identifying | Zero or One to Zero or More | AdTermID | NO | |||
| HsBuildingRooms | Non-Identifying | One To Zero or More | HSBuildingRoomsID | NO | |||
| HSLeaseStatus | Non-Identifying | One To Zero or More | HSLeaseStatusID | NO | |||
| HSMoveOutReason | Non-Identifying | Zero or One to Zero or More | HSMoveOutReasonID | NO | |||
| HousingApplicationStudent | Non-Identifying | One To Zero or More | HSStudentApplicationID | NO | |||
| BillingTransactionCode | Non-Identifying | Zero or One to Zero or More | SaBillCodeID | NO | |||
| Student | Non-Identifying | One To Zero or More | SyStudentID | NO | |||
| StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More | StudentEnrollmentPeriodId | NO | |||
| StudentAcademicYear | Non-Identifying | Zero or One to Zero or More | FaStudentAYID | NO | |||
| Term | Non-Identifying | Zero or One to Zero or More | SaBillTermID | NO | |||
| BillingTransactionCode | Non-Identifying | Zero or One to Zero or More | SaTransCodeID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| HsBuildingRoomsStudents | Non-Identifying | One To Zero or More | NO | ||||
| HousingLeaseScheduledCharge | Non-Identifying | One To Zero or More | NO | ||||
| HousingLeaseDocument | Non-Identifying | One To Zero or More | NO | ||||
| HSStudentLeaseEvent | Non-Identifying | One To Zero or More | NO |
| HousingLease Check Constraints |
| Check Constraint Name | CheckConstraint |
| HousingLease Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.HousingLease |
NO | |||
| Physical (Microsoft SQL Server) dbo.HSStudentLeaseHistory |
NO |
| HousingLease Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Housing |
| HousingLease Data Movement Rules |
| Name | Type | Rule Text/Value |